Bar: Household Income vs YoY, Reset 16
House hold Income vs YoY
Click New Worksheet, Rename 'House hold Income vs YoY', Double click title to edit, Size 11, Bold.
Create Bar chart and YoY
Drag and drop Incom brackets in Columns and Household Income in Rows, Bring cc. YoY Applicants and cc. YoY Units Available to the right axis, Change Marks (SUM(Household Income) to Bar and Measure Values to Line), Fit Entire View, Edit Color --> (House hold Income - #aa557f ), Hide header.
See gif
Format and Tooltip
Select ALL, Drag YoY Applicants and YoY Units to Tooltip, Click Tooltip Add
Income Brackets: <cc.Income Brackets>
Household Income: <SUM(Household Income)>
YoY Units Available: <AGG(cc.YoY Units Available)>
YoY Applicants: <AGG(cc.YoY Applicants)>
Format Chart
See gif
RESET Button
New Worksheet, Rename 'Reset'
See gif
Combination Charts: https://www.youtube.com/watch?v=Ymtc2iHIjwk&t=276s